<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `fanwe_purpose_cate_city_link`;");
E_C("CREATE TABLE `fanwe_purpose_cate_city_link` (
  `cate_id` int(11) NOT NULL,
  `city_id` int(11) NOT NULL,
  `recommend` tinyint(4) NOT NULL DEFAULT '0',
  `rec_sort` int(11) NOT NULL DEFAULT '0',
  KEY `cate_id` (`cate_id`),
  KEY `city_id` (`city_id`),
  KEY `index_001` (`cate_id`,`city_id`),
  KEY `index_002` (`cate_id`,`city_id`,`recommend`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8");
E_D("replace into `fanwe_purpose_cate_city_link` values('1','17','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('1','16','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('1','15','1','98');");
E_D("replace into `fanwe_purpose_cate_city_link` values('7','15','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('2','17','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('2','16','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('2','15','1','100');");
E_D("replace into `fanwe_purpose_cate_city_link` values('3','17','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('3','16','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('3','15','0','99');");
E_D("replace into `fanwe_purpose_cate_city_link` values('4','17','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('4','16','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('4','15','1','97');");
E_D("replace into `fanwe_purpose_cate_city_link` values('5','17','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('5','16','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('5','15','1','96');");
E_D("replace into `fanwe_purpose_cate_city_link` values('6','17','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('6','16','0','0');");
E_D("replace into `fanwe_purpose_cate_city_link` values('6','15','0','95');");

require("../../inc/footer.php");
?>